explain.depesz.com

PostgreSQL's explain analyze made readable

Result: npQZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 696.478 ↑ 1.0 51 1

Limit (cost=85,403.14..85,403.26 rows=51 width=1,726) (actual time=696.466..696.478 rows=51 loops=1)

2. 68.493 696.473 ↑ 212.4 51 1

Sort (cost=85,403.14..85,430.22 rows=10,833 width=1,726) (actual time=696.464..696.473 rows=51 loops=1)

  • Sort Key: ((rkk.regnumcnt + 0)) DESC, inputrkk.id DESC
  • Sort Method: top-N heapsort Memory: 73kB
3. 37.331 627.980 ↓ 3.5 38,342 1

Nested Loop (cost=55,432.75..85,041.73 rows=10,833 width=1,726) (actual time=182.402..627.980 rows=38,342 loops=1)

4. 258.540 436.753 ↓ 3.4 38,474 1

Hash Join (cost=55,432.32..76,618.55 rows=11,484 width=1,525) (actual time=182.377..436.753 rows=38,474 loops=1)

  • Hash Cond: (inputrkk.id = rkkbase.id)
5. 82.747 82.747 ↓ 1.0 700,898 1

Seq Scan on f_dp_inputrkk inputrkk (cost=0.00..18,444.92 rows=700,392 width=628) (actual time=0.016..82.747 rows=700,898 loops=1)

6. 29.079 95.466 ↓ 1.0 38,669 1

Hash (cost=54,968.69..54,968.69 rows=37,090 width=897) (actual time=95.466..95.466 rows=38,669 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11771kB
7. 66.387 66.387 ↓ 1.0 38,669 1

Index Scan using i_5392_1 on f_dp_rkkbase rkkbase (cost=0.43..54,968.69 rows=37,090 width=897) (actual time=0.034..66.387 rows=38,669 loops=1)

  • Index Cond: (module = 179)
  • Filter: ((isdeleted <> 1) AND (module_type = 1015))
  • Rows Removed by Filter: 1744
8. 153.896 153.896 ↑ 1.0 1 38,474

Index Scan using pk_5405 on f_dp_rkk rkk (cost=0.43..0.72 rows=1 width=201) (actual time=0.004..0.004 rows=1 loops=38,474)

  • Index Cond: (id = inputrkk.id)
  • Filter: (regnumcnt IS NOT NULL)
  • Rows Removed by Filter: 0