explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g7km

Settings
# exclusive inclusive rows x rows loops node
1. 58.227 100.943 ↓ 11.0 5,465 1

Gather (cost=1,843.25..12,542.69 rows=496 width=263) (actual time=48.976..100.943 rows=5,465 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.515 42.712 ↓ 8.8 1,822 3

Hash Join (cost=843.25..5,214.10 rows=207 width=159) (actual time=35.020..42.712 rows=1,822 loops=3)

  • Hash Cond: (ci.location_id = loc.location_id)
3. 5.266 42.160 ↓ 8.8 1,822 3

Nested Loop (cost=841.60..5,211.83 rows=207 width=150) (actual time=34.906..42.160 rows=1,822 loops=3)

4. 4.454 36.892 ↓ 8.8 1,822 3

Hash Join (cost=841.18..4,627.09 rows=207 width=137) (actual time=34.869..36.892 rows=1,822 loops=3)

  • Hash Cond: (ci.check_in_id = vd.check_in_id)
5. 22.094 22.340 ↑ 1.2 5,589 3

Parallel Bitmap Heap Scan on check_in ci (cost=16.08..3,710.88 rows=6,476 width=32) (actual time=0.371..22.340 rows=5,589 loops=3)

  • Recheck Cond: ((session_start_time >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND (session_start_time <= '2019-07-01 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Index Recheck: 38050
  • Heap Blocks: lossy=1394
6. 0.246 0.246 ↑ 2.0 23,040 1

Bitmap Index Scan on check_in_session_start_time_idx1 (cost=0.00..12.20 rows=45,567 width=0) (actual time=0.246..0.246 rows=23,040 loops=1)

  • Index Cond: ((session_start_time >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND (session_start_time <= '2019-07-01 00:00:00+00'::timestamp with time zone))
7. 1.718 10.098 ↑ 1.0 6,310 3

Hash (cost=746.22..746.22 rows=6,310 width=121) (actual time=10.098..10.098 rows=6,310 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 1050kB
8. 8.380 8.380 ↑ 1.0 6,310 3

Seq Scan on video_details vd (cost=0.00..746.22 rows=6,310 width=121) (actual time=0.315..8.380 rows=6,310 loops=3)

  • Filter: media_release
  • Rows Removed by Filter: 3412
9. 0.002 0.002 ↑ 1.0 1 5,465

Index Scan using customer_pkey on customer cst (cost=0.42..2.82 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=5,465)

  • Index Cond: (customer_id = vd.customer_id)
10. 0.011 0.037 ↑ 1.0 29 3

Hash (cost=1.29..1.29 rows=29 width=17) (actual time=0.037..0.037 rows=29 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
11. 0.026 0.026 ↑ 1.0 29 3

Seq Scan on location loc (cost=0.00..1.29 rows=29 width=17) (actual time=0.016..0.026 rows=29 loops=3)

12.          

SubPlan (forGather)

13. 0.001 0.004 ↑ 1.0 1 5,465

Nested Loop (cost=0.56..12.64 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=5,465)

14. 0.001 0.001 ↑ 1.0 1 5,465

Index Only Scan using video_details_id_game_id_unique on video_to_game_id vg (cost=0.29..4.33 rows=1 width=5) (actual time=0.001..0.001 rows=1 loops=5,465)

  • Index Cond: (video_details_id = vd.video_details_id)
  • Filter: (game_id <> 'n1'::text)
  • Rows Removed by Filter: 1
  • Heap Fetches: 0
15. 0.002 0.002 ↑ 1.0 1 5,731

Index Scan using game_game_id_idx on game g (cost=0.28..8.29 rows=1 width=25) (actual time=0.002..0.002 rows=1 loops=5,731)

  • Index Cond: (game_id = vg.game_id)
Planning time : 1.007 ms