explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cifu : FooBarraa

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 7.210 ↓ 2.3 261 1

Append (cost=1.98..4,232.86 rows=112 width=299) (actual time=0.200..7.210 rows=261 loops=1)

2. 0.206 5.233 ↓ 2.0 190 1

Nested Loop (cost=1.98..3,337.39 rows=93 width=294) (actual time=0.199..5.233 rows=190 loops=1)

3. 0.150 3.507 ↓ 2.0 190 1

Nested Loop (cost=1.70..2,524.32 rows=93 width=161) (actual time=0.133..3.507 rows=190 loops=1)

4. 0.129 1.647 ↓ 2.0 190 1

Nested Loop (cost=1.27..1,742.94 rows=93 width=125) (actual time=0.095..1.647 rows=190 loops=1)

5. 0.159 1.328 ↓ 2.0 190 1

Nested Loop (cost=0.99..1,191.04 rows=93 width=96) (actual time=0.078..1.328 rows=190 loops=1)

6. 0.120 0.979 ↓ 2.0 190 1

Nested Loop (cost=0.71..639.14 rows=93 width=67) (actual time=0.049..0.979 rows=190 loops=1)

7. 0.479 0.479 ↓ 2.0 190 1

Index Scan using ix_billinglog_exportid on billinglog (cost=0.42..18.77 rows=93 width=36) (actual time=0.027..0.479 rows=190 loops=1)

  • Index Cond: (exportid = '2678'::bigint)
  • Filter: (entitytypeid = 1)
  • Rows Removed by Filter: 71
8. 0.380 0.380 ↑ 1.0 1 190

Index Scan using pk_user on "user" (cost=0.29..6.67 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=190)

  • Index Cond: (id = billinglog.userid)
9. 0.190 0.190 ↑ 1.0 1 190

Index Scan using pk_organisation on organisation userorg (cost=0.28..5.93 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=190)

  • Index Cond: (id = billinglog.userorgid)
10. 0.190 0.190 ↑ 1.0 1 190

Index Scan using pk_organisation on organisation topparentorg (cost=0.28..5.93 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=190)

  • Index Cond: (id = billinglog.topparentorgid)
11. 1.710 1.710 ↑ 1.0 1 190

Index Scan using pk_request on roadworkrequest (cost=0.43..8.40 rows=1 width=40) (actual time=0.009..0.009 rows=1 loops=190)

  • Index Cond: (id = billinglog.entityid)
12. 0.570 0.570 ↑ 1.0 1 190

Index Scan using pk_organisation on organisation roadworkpsmorg (cost=0.28..0.30 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=190)

  • Index Cond: (id = roadworkrequest.roadworkrequestpsmorganisationid)
13.          

SubPlan (for Nested Loop)

14. 0.190 0.950 ↑ 1.0 1 190

Limit (cost=0.42..8.44 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=190)

15. 0.760 0.760 ↑ 1.0 1 190

Index Only Scan using ix_entityid_billinglog on billinglog bl (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=190)

  • Index Cond: (entityid = billinglog.entityid)
  • Heap Fetches: 0
16. 0.118 1.948 ↓ 3.7 71 1

Nested Loop (cost=1.98..893.79 rows=19 width=324) (actual time=0.109..1.948 rows=71 loops=1)

17. 0.052 1.262 ↓ 3.7 71 1

Nested Loop (cost=1.69..727.43 rows=19 width=159) (actual time=0.057..1.262 rows=71 loops=1)

18. 0.065 1.139 ↓ 3.7 71 1

Nested Loop (cost=1.41..589.85 rows=19 width=130) (actual time=0.050..1.139 rows=71 loops=1)

19. 0.073 1.003 ↓ 3.7 71 1

Nested Loop (cost=1.13..452.26 rows=19 width=101) (actual time=0.043..1.003 rows=71 loops=1)

20. 0.109 0.788 ↓ 3.7 71 1

Nested Loop (cost=0.84..305.64 rows=19 width=70) (actual time=0.034..0.788 rows=71 loops=1)

21. 0.111 0.111 ↓ 2.1 71 1

Index Scan using ix_billinglog_exportid on billinglog billinglog_1 (cost=0.42..18.77 rows=34 width=36) (actual time=0.013..0.111 rows=71 loops=1)

  • Index Cond: (exportid = '2678'::bigint)
  • Filter: (entitytypeid = 2)
  • Rows Removed by Filter: 190
22. 0.568 0.568 ↑ 1.0 1 71

Index Scan using pk_permit on permit (cost=0.42..8.44 rows=1 width=38) (actual time=0.008..0.008 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.entityid)
23. 0.142 0.142 ↑ 1.0 1 71

Index Scan using pk_user on "user" user_1 (cost=0.29..7.72 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.userid)
24. 0.071 0.071 ↑ 1.0 1 71

Index Scan using pk_organisation on organisation userorg_1 (cost=0.28..7.24 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.userorgid)
25. 0.071 0.071 ↑ 1.0 1 71

Index Scan using pk_organisation on organisation topparentorg_1 (cost=0.28..7.24 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=71)

  • Index Cond: (id = billinglog_1.topparentorgid)
26. 0.142 0.142 ↑ 1.0 1 71

Index Scan using pk_organisation on organisation permitpsmorg (cost=0.28..0.32 rows=1 width=34) (actual time=0.002..0.002 rows=1 loops=71)

  • Index Cond: (id = permit.permitpublicspacemanagerid)
27.          

SubPlan (for Nested Loop)

28. 0.000 0.426 ↑ 1.0 1 71

Limit (cost=0.42..8.44 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=71)

29. 0.426 0.426 ↑ 1.0 1 71

Index Only Scan using ix_entityid_billinglog on billinglog bl_1 (cost=0.42..8.44 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=71)

  • Index Cond: (entityid = billinglog_1.entityid)
  • Heap Fetches: 0