explain.depesz.com

PostgreSQL's explain analyze made readable

Result: in4c : Optimization for: plan #56ZSg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 13.413 56.301 ↓ 1.0 52,562 1

Hash Left Join (cost=2,348.200..3,948.460 rows=52,504 width=86) (actual time=18.038..56.301 rows=52,562 loops=1)

  • Hash Cond: (alpha."juliet_four" = papa_india."juliet_victor")
2. 19.928 42.873 ↓ 1.0 52,562 1

Hash Right Join (cost=2,347.090..3,692.700 rows=52,504 width=62) (actual time=18.009..42.873 rows=52,562 loops=1)

  • Hash Cond: (alpha."oscar" = quebec."juliet_victor")
3. 5.064 5.064 ↑ 1.0 57,789 1

Seq Scan on echo_echo alpha (cost=0.000..1,193.890 rows=57,789 width=54) (actual time=0.025..5.064 rows=57,789 loops=1)

4. 4.206 17.881 ↓ 1.0 26,281 1

Hash (cost=2,018.880..2,018.880 rows=26,257 width=16) (actual time=17.881..17.881 rows=26,281 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,488kB
5. 13.675 13.675 ↓ 1.0 26,281 1

Seq Scan on three_hotel quebec (cost=0.000..2,018.880 rows=26,257 width=16) (actual time=0.021..13.675 rows=26,281 loops=1)

  • Filter: (("india" five NOT NULL) AND (("xray_delta")::text = 'three_six'::text) AND ("lima" = 1) AND ("papa_victor" = ANY ('xray_charlie'::bigint[])))
  • Rows Removed by Filter: 2,619
6. 0.006 0.015 ↑ 1.0 5 1

Hash (cost=1.050..1.050 rows=5 width=40) (actual time=0.015..0.015 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.009 0.009 ↑ 1.0 5 1

Seq Scan on echo_papa papa_india (cost=0.000..1.050 rows=5 width=40) (actual time=0.008..0.009 rows=5 loops=1)

Planning time : 0.486 ms
Execution time : 57.864 ms