explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aQiC

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 14,802.557 ↑ 1.0 100 1

Limit (cost=512,999.80..513,000.05 rows=100 width=4,800) (actual time=14,802.542..14,802.557 rows=100 loops=1)

2. 338.347 14,802.547 ↑ 897.2 100 1

Sort (cost=512,999.80..513,224.11 rows=89,721 width=4,800) (actual time=14,802.541..14,802.547 rows=100 loops=1)

  • Sort Key: uniform.four
  • Sort Method: top-N heapsort Memory: 130kB
3. 232.119 14,464.200 ↓ 1.1 96,700 1

Nested Loop (cost=0.00..509,570.73 rows=89,721 width=4,800) (actual time=0.094..14,464.200 rows=96,700 loops=1)

4. 221.253 221.253 ↑ 1.0 120,783 1

Seq Scan on lima uniform (cost=0.00..2,096.83 rows=120,783 width=32) (actual time=0.029..221.253 rows=120,783 loops=1)

5. 14,010.828 14,010.828 ↑ 1.0 1 120,783

Index Scan using whiskey on golf (cost=0.00..4.19 rows=1 width=4,768) (actual time=0.115..0.116 rows=1 loops=120,783)

  • Index Cond: (xray = uniform.xray)
  • Filter: ((echo five NULL) AND (kilo = 4))
  • Rows Removed by Filter: 0
Total runtime : 14,803.318 ms