How do I get all results from my query

You can use posts_per_page to return all post from the database
Just little modification in your WP query

<?php
$query = new WP_Query(array('post_type' => 'any','posts_per_page'=>-1));
?>

Try with this modification if it works for you.

Related Posts:

  1. How to Optimize WP site for millions of posts
  2. Get Terms by IDs with IDs order
  3. wpdb get posts by taxonomy SQL
  4. How to List Events by Year and Month Using Advanced Custom Fields?
  5. Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
  6. How many WordPress SQL Queries per page?
  7. Slow wp_enqueue_media()
  8. Advanced Custom Fields – Query Efficiency
  9. How to display lastest post date in the homepage?
  10. Get a user’s most recent post title
  11. Different Main Navigation per category
  12. Show recent products first but “sold out last” in query
  13. How to tell if $query_var isset?
  14. Show All Posts Insert Edit Link
  15. Get posts by category with pure SQL query
  16. can’t get query to order posts by acf datepicker
  17. Sorting Grids with Essential Grid and Events Manger
  18. The use of including upgrade.php when building custom queries
  19. Get the timout value of a saved transient?
  20. Help with wordpress custom query and advanced custom fields plugin
  21. Does meta_query work within get_posts array?
  22. Mysql / WordPress killing my server with 80k users [closed]
  23. Query all posts and not repeat the same tag
  24. Slow meta_query with about 4 milion record on wp_postmeta
  25. How to show more than 5 posts?
  26. WordPress Find Duplicate Post By Content
  27. WP Query Sort by meta value (date)
  28. mySQL query. ORDER BY meta_key
  29. how to query multiple categories in wordpress?
  30. Disable the MySQL query in the main query
  31. Strange string in console from wpdb query
  32. Update slug (URL) of pending posts via phpMyAdmin
  33. Insert static element only once in query archive
  34. How to run a mysql query when admin updates user role?
  35. How can I get the query that would be run for the archive page?
  36. Query metas (and not : query posts by metas)
  37. Select query for a login
  38. What’s wrong with my $wpdb prepare?
  39. where should I reset query after using get_results?
  40. Missing posts in a query
  41. Alter a specific query on WordPress
  42. Exclude featured image and custom field from this get_attachment query
  43. Protect sequence of pages with same password for each of two groups of users
  44. How is it possible to get top comment from all children?
  45. wpdb print all post meta
  46. Form and custom query problem
  47. Export Specific User data without plugin
  48. Create Indexes for Slow Queries
  49. I want to create a filter for the query string is this possible?
  50. How to write: $wpdb->update having WHERE NOT value pair in the array
  51. Exclude all sticky posts front page twenty twelve
  52. All in One Calendar Plugin Custom Post Type Query [closed]
  53. Get Posts from Last 24 hours and Sort them via GD Star Rating
  54. Query returning same results even though the ID changes
  55. Why my query ‘REPLACE INTO…’ does not work?
  56. wpdb COALESCE won’t work
  57. get csv of users with user_meta
  58. Custom SQL Query passing array to WHERE p.id
  59. Restrict query to last day with posts
  60. Custom query object with Simple-Fields custom date field
  61. Query does not return content
  62. Query posts dynamic date range
  63. Parse query filter in wordpress and relation
  64. get posts by tag to showing in a widget
  65. Customizing the_tags output?
  66. Mysql query not working on WordPress 4.2.2
  67. Querying with WP query using meta key price
  68. Taxonomy filter under Polylang
  69. Select column name dynamically mySQL Query
  70. How to create an overview of posts with the same tag?
  71. create a link to a random post within the current category
  72. Pagination not working on custom post types with rewrite slug
  73. JetEngine Query Builder – order by value from repeater
  74. Change pure SQL database query to WordPress post query?
  75. Filter orders by modify date
  76. How to add url parameter to every search query in SearchWp?
  77. How can I get posts by 2 meta keys, prioritising one of them?
  78. Heavy meta query causing SQL crash
  79. Sort by postmeta on when searching
  80. Pulling an ACF into a query
  81. Speed up search query that searches in post meta?
  82. implementing my wp_query using $wpdb class
  83. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  84. Using cron for multiple queries
  85. very slow wordpress query with default query
  86. Sort loop with query in the link
  87. About WP’s save_post action
  88. $wpdb: how to use a query as a base for another query?
  89. Custom Query problem access the values
  90. Set posts per page for parent category and it’s all children
  91. Exclude sticky posts from query
  92. list or get meta_key where meta_value is ‘something’
  93. If more than 1 image show post link?
  94. Rewrite Query_Var URL Parameter with Slug
  95. How to query different categories on index?
  96. How to specify what kind of is_single post?
  97. Can’t See Media Queries with Inspect Tool [closed]
  98. Print data from wordpress sql query
  99. Can I create my own query in wordpress with traditional methods?
  100. How to show sticky posts on all pages of the pagination, not just the first page?