explain.depesz.com

PostgreSQL's explain analyze made readable

Result: liVa

Settings
# exclusive inclusive rows x rows loops node
1. 7.003 36.845 ↑ 1.0 2,765 1

Hash Left Join (cost=255.91..8,002.50 rows=2,765 width=1,326) (actual time=0.611..36.845 rows=2,765 loops=1)

  • Hash Cond: (p.kod_doc = d.item)
2. 0.449 4.603 ↑ 1.0 2,765 1

Hash Left Join (cost=95.78..673.73 rows=2,765 width=686) (actual time=0.231..4.603 rows=2,765 loops=1)

  • Hash Cond: (p.author = avt.aspnetuserid)
3. 0.563 4.146 ↑ 1.0 2,765 1

Hash Left Join (cost=94.67..656.19 rows=2,765 width=428) (actual time=0.221..4.146 rows=2,765 loops=1)

  • Hash Cond: (p.userid = usr.item)
4. 0.580 3.575 ↑ 1.0 2,765 1

Hash Left Join (cost=93.56..641.67 rows=2,765 width=370) (actual time=0.211..3.575 rows=2,765 loops=1)

  • Hash Cond: (p.kod_ksch = ksch.item)
5. 1.986 2.887 ↑ 1.0 2,765 1

Hash Left Join (cost=46.92..587.67 rows=2,765 width=361) (actual time=0.100..2.887 rows=2,765 loops=1)

  • Hash Cond: (p.kod_dsch = dsch.item)
6. 0.810 0.810 ↑ 1.0 2,765 1

Index Scan using ix_prov_kod_doc_organizationid on prov p (cost=0.28..533.68 rows=2,765 width=356) (actual time=0.006..0.810 rows=2,765 loops=1)

  • Index Cond: (organizationid = 1)
7. 0.026 0.091 ↑ 1.0 295 1

Hash (cost=42.95..42.95 rows=295 width=13) (actual time=0.091..0.091 rows=295 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
8. 0.065 0.065 ↑ 1.0 295 1

Seq Scan on sprsch dsch (cost=0.00..42.95 rows=295 width=13) (actual time=0.008..0.065 rows=295 loops=1)

9. 0.056 0.108 ↑ 1.0 295 1

Hash (cost=42.95..42.95 rows=295 width=13) (actual time=0.108..0.108 rows=295 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
10. 0.052 0.052 ↑ 1.0 295 1

Seq Scan on sprsch ksch (cost=0.00..42.95 rows=295 width=13) (actual time=0.005..0.052 rows=295 loops=1)

11. 0.002 0.008 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=62) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on sprusr usr (cost=0.00..1.05 rows=5 width=62) (actual time=0.005..0.006 rows=5 loops=1)

13. 0.004 0.008 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=274) (actual time=0.008..0.008 rows=5 loops=1)

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

Seq Scan on sprusr avt (cost=0.00..1.05 rows=5 width=274) (actual time=0.004..0.004 rows=5 loops=1)

15. 0.132 0.354 ↑ 1.0 939 1

Hash (cost=148.39..148.39 rows=939 width=31) (actual time=0.354..0.354 rows=939 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 70kB
16. 0.222 0.222 ↑ 1.0 939 1

Seq Scan on doc d (cost=0.00..148.39 rows=939 width=31) (actual time=0.004..0.222 rows=939 loops=1)

17.          

SubPlan (for Hash Left Join)

18. 11.060 13.825 ↑ 1.0 1 2,765

Limit (cost=0.00..1.28 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=2,765)

19. 2.765 2.765 ↑ 1.0 1 2,765

Seq Scan on sprjon jon (cost=0.00..1.28 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=2,765)

  • Filter: ((nom_j = p.nom_j) AND ((dt_close = '1900-01-01 00:00:00'::timestamp without time zone) OR (dt_close > now())))
  • Rows Removed by Filter: 8
20. 8.295 11.060 ↑ 1.0 1 2,765

Limit (cost=0.00..1.28 rows=1 width=516) (actual time=0.004..0.004 rows=1 loops=2,765)

21. 2.765 2.765 ↑ 1.0 1 2,765

Seq Scan on sprjon jon_1 (cost=0.00..1.28 rows=1 width=516) (actual time=0.001..0.001 rows=1 loops=2,765)

  • Filter: ((nom_j = p.nom_j) AND ((dt_close = '1900-01-01 00:00:00'::timestamp without time zone) OR (dt_close > now())))
  • Rows Removed by Filter: 8
Planning time : 1.099 ms
Execution time : 37.009 ms