explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8rTC

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 599.748 ↑ 1.0 1 1

Limit (cost=34,106.00..34,106.00 rows=1 width=4) (actual time=599.744..599.748 rows=1 loops=1)

2. 74.493 599.742 ↑ 1.0 1 1

Sort (cost=34,106.00..34,106.00 rows=1 width=4) (actual time=599.742..599.742 rows=1 loops=1)

  • Sort Key: c.c DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 257.529 525.249 ↓ 692,900.0 692,900 1

Hash Left Join (cost=8,931.00..34,105.99 rows=1 width=4) (actual time=195.250..525.249 rows=692,900 loops=1)

  • Hash Cond: (c.c = no_nokia.no)
  • Filter: (no_nokia.ne IS NULL)
  • Rows Removed by Filter: 107100
4. 167.570 167.570 ↑ 1.0 800,000 1

Function Scan on generate_series c (cost=0.00..8,000.00 rows=800,000 width=4) (actual time=94.259..167.570 rows=800,000 loops=1)

5. 37.533 100.150 ↓ 1.0 107,101 1

Hash (cost=7,605.40..7,605.40 rows=106,048 width=12) (actual time=100.150..100.150 rows=107,101 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5731kB
6. 51.688 62.617 ↓ 1.0 107,101 1

Bitmap Heap Scan on no_nokia (cost=1,245.80..7,605.40 rows=106,048 width=12) (actual time=11.701..62.617 rows=107,101 loops=1)

  • Recheck Cond: ((ne)::text = 'MSSBO411'::text)
  • Heap Blocks: exact=5034
7. 10.929 10.929 ↓ 1.0 107,101 1

Bitmap Index Scan on index_no_nokia_ne (cost=0.00..1,219.29 rows=106,048 width=0) (actual time=10.928..10.929 rows=107,101 loops=1)

  • Index Cond: ((ne)::text = 'MSSBO411'::text)
Planning time : 0.311 ms
Execution time : 609.032 ms