explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5fdg : Test obfuscated query

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.029 0.611 ↑ 4.0 8 1

Sort (cost=32.93..33.01 rows=32 width=224) (actual time=0.606..0.611 rows=8 loops=1)

  • Sort Key: two.xray, quebec.yankee
  • Sort Method: quicksort Memory: 27kB
2. 0.086 0.582 ↑ 4.0 8 1

Hash Join (cost=1.09..32.13 rows=32 width=224) (actual time=0.140..0.582 rows=8 loops=1)

  • Hash Cond: (quebec.bravo = two.echo)
3. 0.440 0.440 ↓ 2.1 137 1

Seq Scan on sierra_four quebec (cost=0.00..29.89 rows=65 width=73) (actual time=0.045..0.440 rows=137 loops=1)

  • Filter: ((november_quebec = ANY ('golf'::"char"[])) AND four(echo))
  • Rows Removed by Filter: 258
4. 0.012 0.056 ↑ 2.0 1 1

Hash (cost=1.07..1.07 rows=2 width=68) (actual time=0.055..0.056 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.044 0.044 ↑ 2.0 1 1

Seq Scan on lima two (cost=0.00..1.07 rows=2 width=68) (actual time=0.042..0.044 rows=1 loops=1)

  • Filter: ((xray <> 'sierra_oscar'::name) AND (xray <> 'november_whiskey'::name) AND (xray !~ 'tango'::text))
  • Rows Removed by Filter: 3
Planning time : 0.626 ms
Execution time : 0.704 ms