explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0gSo : #coronavirus chronotope

Settings
# exclusive inclusive rows x rows loops node
1. 23.104 3,182.250 ↓ 19.7 6,641 1

Hash Join (cost=392,534.88..510,541.28 rows=337 width=44) (actual time=2,238.057..3,182.250 rows=6,641 loops=1)

  • Hash Cond: ((ht.node_id)::text = (mn.node_id)::text)
2. 923.107 3,151.549 ↓ 4.4 133,727 1

Bitmap Heap Scan on hits_twitter_hashtags ht (cost=366,336.02..484,262.79 rows=30,334 width=40) (actual time=2,229.978..3,151.549 rows=133,727 loops=1)

  • Recheck Cond: (((hit_value)::text = 'Coronavirus'::text) AND (hit_time >= '2020-04-26 00:00:00'::timestamp without time zone) AND (hit_time <= '2020-05-26 00:00:00'::timestamp without time zone))
  • Rows Removed by Index Recheck: 8280273
  • Heap Blocks: lossy=104250
3. 79.694 2,228.442 ↓ 0.0 0 1

BitmapAnd (cost=366,336.02..366,336.02 rows=30,334 width=0) (actual time=2,228.442..2,228.442 rows=0 loops=1)

4. 347.652 347.652 ↑ 1.0 3,146,353 1

Bitmap Index Scan on hashtags_value_idx (cost=0.00..73,902.14 rows=3,165,542 width=0) (actual time=347.652..347.652 rows=3,146,353 loops=1)

  • Index Cond: ((hit_value)::text = 'Coronavirus'::text)
5. 1,801.096 1,801.096 ↓ 2.8 37,653,361 1

Bitmap Index Scan on hashtags_time_idx (cost=0.00..292,418.46 rows=13,582,188 width=0) (actual time=1,801.096..1,801.096 rows=37,653,361 loops=1)

  • Index Cond: ((hit_time >= '2020-04-26 00:00:00'::timestamp without time zone) AND (hit_time <= '2020-05-26 00:00:00'::timestamp without time zone))
6. 2.382 7.597 ↑ 1.1 13,883 1

Hash (cost=26,004.61..26,004.61 rows=15,540 width=16) (actual time=7.597..7.597 rows=13,883 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 795kB
7. 5.215 5.215 ↑ 1.1 13,883 1

Index Scan using map_nodes_map_node_idx on map_nodes mn (cost=0.43..26,004.61 rows=15,540 width=16) (actual time=0.014..5.215 rows=13,883 loops=1)

  • Index Cond: (map_id = 2467)
Planning time : 0.649 ms
Execution time : 3,184.695 ms