explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tZqs

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 25,670.707 ↑ 1.0 50 1

Limit (cost=19,831.75..19,831.87 rows=50 width=258) (actual time=25,670.696..25,670.707 rows=50 loops=1)

2. 8.358 25,670.695 ↑ 8.3 50 1

Sort (cost=19,831.75..19,832.79 rows=417 width=258) (actual time=25,670.694..25,670.695 rows=50 loops=1)

  • Sort Key: v.create_dt DESC, v.version_date DESC
  • Sort Method: top-N heapsort Memory: 38kB
3. 31.851 25,662.337 ↓ 21.0 8,748 1

Nested Loop Left Join (cost=41.81..19,817.90 rows=417 width=258) (actual time=0.314..25,662.337 rows=8,748 loops=1)

4. 1.800 25,612.990 ↓ 21.0 8,748 1

Nested Loop (cost=41.54..19,681.41 rows=417 width=564) (actual time=0.296..25,612.990 rows=8,748 loops=1)

5. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on ca_versop vo (cost=0.00..1.07 rows=1 width=45) (actual time=0.021..0.023 rows=1 loops=1)

  • Filter: (id = 3)
  • Rows Removed by Filter: 5
6. 8.272 25,611.167 ↓ 21.0 8,748 1

Nested Loop (cost=41.54..19,676.17 rows=417 width=519) (actual time=0.272..25,611.167 rows=8,748 loops=1)

7. 5.365 32.491 ↓ 21.0 8,748 1

Nested Loop (cost=0.00..2,342.14 rows=417 width=511) (actual time=0.030..32.491 rows=8,748 loops=1)

  • Join Filter: (v.listing_id = lis.id)
  • Rows Removed by Join Filter: 17496
8. 0.027 0.027 ↓ 3.0 3 1

Seq Scan on ca_listing lis (cost=0.00..2.34 rows=1 width=134) (actual time=0.016..0.027 rows=3 loops=1)

  • Filter: (((listing_type)::text = 'Реестр'::text) AND ((listing_code)::text = ANY ('{F002,F003,F004}'::text[])))
  • Rows Removed by Filter: 18
9. 27.099 27.099 ↓ 1.0 8,748 3

Seq Scan on ca_version v (cost=0.00..2,230.46 rows=8,747 width=393) (actual time=0.005..9.033 rows=8,748 loops=3)

  • Filter: (operation_id = 3)
  • Rows Removed by Filter: 26251
10. 131.220 25,570.404 ↑ 1.0 1 8,748

Aggregate (cost=41.54..41.55 rows=1 width=8) (actual time=2.923..2.923 rows=1 loops=8,748)

11. 367.398 25,439.184 ↓ 1.7 117 8,748

Hash Join (cost=1.49..41.37 rows=68 width=1,386) (actual time=0.025..2.908 rows=117 loops=8,748)

  • Hash Cond: (e.message_type = mt.id)
12. 25,071.768 25,071.768 ↑ 2.2 123 8,748

Index Scan using idx_ca_lderror_version_id on ca_lderror e (cost=0.43..38.61 rows=271 width=1,390) (actual time=0.010..2.866 rows=123 loops=8,748)

  • Index Cond: (version_id = v.id)
13. 0.004 0.018 ↑ 1.0 1 1

Hash (cost=1.05..1.05 rows=1 width=4) (actual time=0.018..0.018 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on ca_msgtyp mt (cost=0.00..1.05 rows=1 width=4) (actual time=0.012..0.014 rows=1 loops=1)

  • Filter: ((code)::text = '2'::text)
  • Rows Removed by Filter: 3
15. 17.496 17.496 ↑ 1.0 1 8,748

Index Scan using user_pkey on "user" u (cost=0.27..0.29 rows=1 width=11) (actual time=0.002..0.002 rows=1 loops=8,748)

  • Index Cond: (id = v.created_user_id)