explain.depesz.com

PostgreSQL's explain analyze made readable

Result: myu : printted products source

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 250.833 ↑ 1.0 10 1

Limit (cost=13,022.730..13,022.760 rows=10 width=85) (actual time=250.832..250.833 rows=10 loops=1)

2. 2.999 250.832 ↑ 1,196.1 10 1

Sort (cost=13,022.730..13,052.630 rows=11,961 width=85) (actual time=250.831..250.832 rows=10 loops=1)

  • Sort Key: echo.quebec_juliet DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 48.909 247.833 ↓ 1.0 12,000 1

HashAggregate (cost=12,644.650..12,764.260 rows=11,961 width=85) (actual time=243.101..247.833 rows=12,000 loops=1)

  • Group Key: echo.quebec_seven
4. 72.336 198.924 ↑ 1.0 168,000 1

Hash Join (cost=1,595.750..12,208.520 rows=174,453 width=85) (actual time=32.653..198.924 rows=168,000 loops=1)

  • Hash Cond: (november.oscar_november = echo.quebec_seven)
5. 93.976 93.976 ↑ 1.0 168,000 1

Seq Scan on november (cost=0.000..8,216.000 rows=173,930 width=4) (actual time=0.017..93.976 rows=168,000 loops=1)

  • Filter: ((foxtrot five_romeo TRUE) AND (five_sierra = 0) AND (oscar_charlie = ANY ('kilo'::integer[])))
  • Rows Removed by Filter: 96000
6. 4.777 32.612 ↓ 1.0 12,000 1

Hash (cost=1,445.790..1,445.790 rows=11,997 width=89) (actual time=32.612..32.612 rows=12,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1675kB
7. 7.388 27.835 ↓ 1.0 12,000 1

Hash Join (cost=530.030..1,445.790 rows=11,997 width=89) (actual time=12.136..27.835 rows=12,000 loops=1)

  • Hash Cond: (four.xray = echo.quebec_seven)
8. 8.346 8.346 ↓ 1.0 12,000 1

Seq Scan on four (cost=0.000..751.260 rows=11,997 width=4) (actual time=0.007..8.346 rows=12,000 loops=1)

  • Filter: (five_sierra = 0)
  • Rows Removed by Filter: 24000
9. 4.879 12.101 ↓ 1.0 12,000 1

Hash (cost=380.510..380.510 rows=11,961 width=85) (actual time=12.101..12.101 rows=12,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1628kB
10. 7.222 7.222 ↓ 1.0 12,000 1

Seq Scan on echo (cost=0.000..380.510 rows=11,961 width=85) (actual time=0.010..7.222 rows=12,000 loops=1)

  • Filter: ((yankee five_romeo NULL) AND (victor = 1))
Planning time : 2.146 ms
Execution time : 250.969 ms