explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aa8

Settings
# exclusive inclusive rows x rows loops node
1. 28.176 101.201 ↓ 11.0 5,465 1

Gather (cost=1,841.60..12,540.42 rows=496 width=250) (actual time=45.820..101.201 rows=5,465 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 4.010 45.700 ↓ 8.8 1,822 3

Nested Loop (cost=841.60..5,211.83 rows=207 width=146) (actual time=39.685..45.700 rows=1,822 loops=3)

3. 1.887 41.688 ↓ 8.8 1,822 3

Hash Join (cost=841.18..4,627.09 rows=207 width=133) (actual time=39.650..41.688 rows=1,822 loops=3)

  • Hash Cond: (ci.check_in_id = vd.check_in_id)
4. 22.482 22.736 ↑ 1.2 5,589 3

Parallel Bitmap Heap Scan on check_in ci (cost=16.08..3,710.88 rows=6,476 width=28) (actual time=0.183..22.736 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=1227
5. 0.254 0.254 ↑ 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.254..0.254 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))
6. 4.541 17.065 ↑ 1.0 6,310 3

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

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

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

  • Filter: media_release
  • Rows Removed by Filter: 3412
8. 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)
9.          

SubPlan (for Gather)

10. 4.933 27.325 ↑ 1.0 1 5,465

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

11. 10.930 10.930 ↑ 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.002..0.002 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
12. 11.462 11.462 ↑ 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 : 0.904 ms