explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i9FV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.495 ↓ 0.0 0 1

Limit (cost=1,827.23..1,827.23 rows=1 width=2,276) (actual time=2.495..2.495 rows=0 loops=1)

2. 0.007 2.494 ↓ 0.0 0 1

Sort (cost=1,827.23..1,827.23 rows=1 width=2,276) (actual time=2.494..2.494 rows=0 loops=1)

  • Sort Key: checkinbas0_.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 2.487 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,741.70..1,827.22 rows=1 width=2,276) (actual time=2.487..2.487 rows=0 loops=1)

4. 0.000 2.487 ↓ 0.0 0 1

Nested Loop (cost=1,741.27..1,823.26 rows=1 width=2,158) (actual time=2.487..2.487 rows=0 loops=1)

5. 0.003 2.487 ↓ 0.0 0 1

Nested Loop (cost=1,740.85..1,822.66 rows=1 width=1,584) (actual time=2.487..2.487 rows=0 loops=1)

  • Join Filter: (organizati4_.id = customer2_.fk_organization_unit)
6. 0.015 0.036 ↑ 1.0 9 1

Nested Loop Left Join (cost=0.00..3.18 rows=9 width=611) (actual time=0.020..0.036 rows=9 loops=1)

  • Join Filter: (organizati4_.id = organizati4_1_.fk_organization_unit)
  • Rows Removed by Join Filter: 36
7. 0.012 0.012 ↑ 1.0 9 1

Seq Scan on organization_unit organizati4_ (cost=0.00..1.09 rows=9 width=250) (actual time=0.007..0.012 rows=9 loops=1)

8. 0.005 0.009 ↑ 1.6 5 9

Materialize (cost=0.00..1.12 rows=8 width=361) (actual time=0.001..0.001 rows=5 loops=9)

9. 0.004 0.004 ↑ 1.0 8 1

Seq Scan on organization_unit_additional_masterdata organizati4_1_ (cost=0.00..1.08 rows=8 width=361) (actual time=0.003..0.004 rows=8 loops=1)

10. 0.003 2.448 ↓ 0.0 0 9

Materialize (cost=1,740.85..1,819.35 rows=1 width=973) (actual time=0.272..0.272 rows=0 loops=9)

11. 0.000 2.445 ↓ 0.0 0 1

Nested Loop (cost=1,740.85..1,819.35 rows=1 width=973) (actual time=2.445..2.445 rows=0 loops=1)

12. 0.001 2.445 ↓ 0.0 0 1

Nested Loop (cost=1,740.43..1,817.85 rows=1 width=245) (actual time=2.445..2.445 rows=0 loops=1)

13. 0.002 2.444 ↓ 0.0 0 1

Bitmap Heap Scan on access_identification checkinbas0_ (cost=1,740.14..1,809.54 rows=1 width=126) (actual time=2.444..2.444 rows=0 loops=1)

  • Recheck Cond: (uid ~~ 'R%'::text)
  • Filter: ((NOT archived) AND (type = 'CHECKIN_BASED_PURCHASED_CONTINGENT'::text))
14. 2.442 2.442 ↓ 0.0 0 1

Bitmap Index Scan on access_identification_uid_idx (cost=0.00..1,740.14 rows=18 width=0) (actual time=2.442..2.442 rows=0 loops=1)

  • Index Cond: (uid ~~ 'R%'::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using purchased_contingent_pkey on purchased_contingent purchasedc1_ (cost=0.29..8.31 rows=1 width=119) (never executed)

  • Index Cond: (id = checkinbas0_.fk_purchased_contingent)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using customer_pkey on customer customer2_ (cost=0.42..1.50 rows=1 width=728) (never executed)

  • Index Cond: (id = purchasedc1_.fk_customer)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address address3_ (cost=0.42..0.60 rows=1 width=574) (never executed)

  • Index Cond: (id = customer2_.fk_address)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using checkin_pkey on checkin checkin5_ (cost=0.43..3.95 rows=1 width=110) (never executed)

  • Index Cond: (customer2_.fk_active_checkin = id)
Planning time : 4.011 ms
Execution time : 2.824 ms