explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S5lU

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 19,816.891 ↑ 1.0 50 1

Limit (cost=2,336.22..4,327.94 rows=50 width=258) (actual time=36.984..19,816.891 rows=50 loops=1)

2. 0.072 19,816.883 ↑ 8.5 50 1

Result (cost=2,336.22..19,305.68 rows=426 width=258) (actual time=36.983..19,816.883 rows=50 loops=1)

3. 5.502 36.961 ↑ 8.5 50 1

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

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

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

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

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

6. 0.012 0.012 ↑ 1.0 1 1

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

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

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

  • Hash Cond: (v.listing_id = lis.id)
8. 8.806 8.806 ↑ 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.006..8.806 rows=8,747 loops=1)

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

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

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

Seq Scan on ca_listing lis (cost=0.00..2.34 rows=1 width=134) (actual time=0.009..0.015 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.061 0.131 ↑ 1.0 327 1

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

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

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

13.          

SubPlan (forResult)

14. 26.350 19,779.850 ↑ 1.0 1 50

Aggregate (cost=39.79..39.80 rows=1 width=8) (actual time=395.597..395.597 rows=1 loops=50)

15. 19,753.500 19,753.500 ↓ 3.6 893 50

Index Scan using idx_ca_lderror_version_id on ca_lderror e (cost=0.43..39.16 rows=250 width=1,403) (actual time=0.007..395.070 rows=893 loops=50)

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