explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2PEI

Settings
# exclusive inclusive rows x rows loops node
1. 0.273 0.855 ↓ 2.1 776 1

Hash Right Join (cost=33.120..54.080 rows=362 width=76) (actual time=0.539..0.855 rows=776 loops=1)

  • Hash Cond: (november.foxtrot = golf_tango.quebec)
2. 0.067 0.067 ↑ 1.0 752 1

Seq Scan on november (cost=0.000..14.520 rows=752 width=36) (actual time=0.004..0.067 rows=752 loops=1)

3. 0.103 0.515 ↓ 2.0 464 1

Hash (cost=30.170..30.170 rows=236 width=44) (actual time=0.515..0.515 rows=464 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
4. 0.069 0.412 ↓ 2.0 464 1

Hash Left Join (cost=19.390..30.170 rows=236 width=44) (actual time=0.216..0.412 rows=464 loops=1)

  • Hash Cond: (papa.quebec = golf_papa.four)
5. 0.114 0.296 ↓ 2.0 464 1

Hash Right Join (cost=14.600..23.800 rows=236 width=35) (actual time=0.160..0.296 rows=464 loops=1)

  • Hash Cond: (golf_tango.four = papa.quebec)
6. 0.042 0.042 ↑ 1.0 490 1

Seq Scan on golf_tango (cost=0.000..7.900 rows=490 width=14) (actual time=0.008..0.042 rows=490 loops=1)

7. 0.066 0.140 ↓ 1.5 347 1

Hash (cost=11.650..11.650 rows=236 width=25) (actual time=0.140..0.140 rows=347 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
8. 0.074 0.074 ↓ 1.5 347 1

Seq Scan on papa (cost=0.000..11.650 rows=236 width=25) (actual time=0.008..0.074 rows=347 loops=1)

  • Filter: (((juliet)::text = 'six'::text) AND ((two)::text = 'five'::text))
  • Rows Removed by Filter: 163
9. 0.024 0.047 ↑ 1.0 151 1

Hash (cost=2.900..2.900 rows=151 width=13) (actual time=0.047..0.047 rows=151 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
10. 0.023 0.023 ↑ 1.0 151 1

Seq Scan on golf_papa (cost=0.000..2.900 rows=151 width=13) (actual time=0.006..0.023 rows=151 loops=1)

  • Filter: ((golf_tango)::text = 'zulu'::text)
  • Rows Removed by Filter: 1
Planning time : 1.052 ms
Execution time : 0.966 ms