explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QFxw

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 19,006.349 ↑ 1.0 50 1

Limit (cost=2,336.22..4,366.57 rows=50 width=258) (actual time=36.374..19,006.349 rows=50 loops=1)

2. 0.055 19,006.340 ↑ 8.5 50 1

Result (cost=2,336.22..19,634.86 rows=426 width=258) (actual time=36.373..19,006.340 rows=50 loops=1)

3. 5.450 36.335 ↑ 8.5 50 1

Sort (cost=2,336.22..2,337.28 rows=426 width=250) (actual time=36.323..36.335 rows=50 loops=1)

  • Sort Key: v.create_dt DESC, v.version_date DESC
  • Sort Method: top-N heapsort Memory: 38kB
4. 16.592 30.885 ↓ 20.5 8,747 1

Hash Left Join (cost=25.87..2,322.06 rows=426 width=250) (actual time=0.240..30.885 rows=8,747 loops=1)

  • Hash Cond: (v.created_user_id = u.id)
5. 1.538 14.142 ↓ 20.5 8,747 1

Nested Loop (cost=2.35..2,283.11 rows=426 width=556) (actual time=0.074..14.142 rows=8,747 loops=1)

6. 0.011 0.011 ↑ 1.0 1 1

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

  • Filter: (id = 3)
  • Rows Removed by Filter: 5
7. 4.175 12.593 ↓ 20.5 8,747 1

Hash Join (cost=2.35..2,277.77 rows=426 width=511) (actual time=0.062..12.593 rows=8,747 loops=1)

  • Hash Cond: (v.listing_id = lis.id)
8. 8.393 8.393 ↑ 1.0 8,747 1

Seq Scan on ca_version v (cost=0.00..2,237.59 rows=8,952 width=393) (actual time=0.009..8.393 rows=8,747 loops=1)

  • Filter: (operation_id = 3)
  • Rows Removed by Filter: 26250
9. 0.009 0.025 ↓ 3.0 3 1

Hash (cost=2.34..2.34 rows=1 width=134) (actual time=0.025..0.025 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.016 0.016 ↓ 3.0 3 1

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

  • Filter: (((listing_type)::text = 'Реестр'::text) AND ((listing_code)::text = ANY ('{F002,F003,F004}'::text[])))
  • Rows Removed by Filter: 18
11. 0.068 0.151 ↑ 1.0 327 1

Hash (cost=19.34..19.34 rows=334 width=11) (actual time=0.151..0.151 rows=327 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
12. 0.083 0.083 ↑ 1.0 327 1

Seq Scan on "user" u (cost=0.00..19.34 rows=334 width=11) (actual time=0.002..0.083 rows=327 loops=1)

13.          

SubPlan (forResult)

14. 27.442 18,969.950 ↑ 1.0 1 50

Aggregate (cost=40.56..40.57 rows=1 width=8) (actual time=379.399..379.399 rows=1 loops=50)

15.          

Initplan (forAggregate)

16. 0.000 0.008 ↑ 1.0 1 1

Limit (cost=0.00..1.05 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

17. 0.008 0.008 ↑ 1.0 1 1

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

  • Filter: ((code)::text = '2'::text)
  • Rows Removed by Filter: 1
18. 18,942.500 18,942.500 ↓ 9.9 893 50

Index Scan using idx_ca_lderror_version_id on ca_lderror e (cost=0.43..39.29 rows=90 width=1,386) (actual time=0.008..378.850 rows=893 loops=50)

  • Index Cond: (version_id = v.id)
  • Filter: (message_type = $0)
  • Rows Removed by Filter: 1