explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ritg

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 11.044 ↑ 56.4 21 1

Hash Left Join (cost=409.65..17,531.27 rows=1,185 width=1,141) (actual time=10.840..11.044 rows=21 loops=1)

  • Hash Cond: (bankaccoun1_.bank_pk = bankentity2_.pk)
2. 0.024 7.312 ↑ 56.4 21 1

Hash Left Join (cost=239.03..17,344.79 rows=1,185 width=1,107) (actual time=7.121..7.312 rows=21 loops=1)

  • Hash Cond: (orginfoent5_.pk = orgverific6_.org_info_pk)
3. 0.034 6.661 ↑ 56.4 21 1

Hash Left Join (cost=204.48..17,305.62 rows=1,185 width=1,031) (actual time=6.483..6.661 rows=21 loops=1)

  • Hash Cond: (accountent4_.org_info_pk = orginfoent5_.pk)
4. 0.053 5.541 ↑ 56.4 21 1

Hash Left Join (cost=160.52..17,247.22 rows=1,185 width=991) (actual time=5.377..5.541 rows=21 loops=1)

  • Hash Cond: (bookentity3_.account_pk = accountent4_.pk)
5. 0.033 2.007 ↑ 56.4 21 1

Nested Loop Left Join (cost=1.42..17,071.83 rows=1,185 width=859) (actual time=1.864..2.007 rows=21 loops=1)

6. 0.025 1.932 ↑ 56.4 21 1

Nested Loop Left Join (cost=0.99..9,256.58 rows=1,185 width=809) (actual time=1.855..1.932 rows=21 loops=1)

7. 1.256 1.256 ↑ 56.4 21 1

Index Scan using ix_txn_page_doc_pk on txn txns0_ (cost=0.57..227.33 rows=1,185 width=109) (actual time=1.249..1.256 rows=21 loops=1)

  • Index Cond: (page_doc_pk = 123)
8. 0.651 0.651 ↑ 1.0 1 21

Index Scan using pk_bank_account on bank_account bankaccoun1_ (cost=0.42..7.61 rows=1 width=700) (actual time=0.030..0.031 rows=1 loops=21)

  • Index Cond: (txns0_.bank_account_pk = pk)
9. 0.042 0.042 ↑ 1.0 1 21

Index Scan using book_pkey on book bookentity3_ (cost=0.42..6.59 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=21)

  • Index Cond: (bankaccoun1_.book_pk = pk)
10. 1.869 3.481 ↓ 1.0 3,269 1

Hash (cost=118.49..118.49 rows=3,249 width=132) (actual time=3.481..3.481 rows=3,269 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 592kB
11. 1.612 1.612 ↓ 1.0 3,269 1

Seq Scan on account accountent4_ (cost=0.00..118.49 rows=3,249 width=132) (actual time=0.009..1.612 rows=3,269 loops=1)

12. 0.538 1.086 ↓ 1.0 1,294 1

Hash (cost=27.87..27.87 rows=1,287 width=40) (actual time=1.086..1.086 rows=1,294 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 116kB
13. 0.548 0.548 ↓ 1.0 1,294 1

Seq Scan on org_info orginfoent5_ (cost=0.00..27.87 rows=1,287 width=40) (actual time=0.009..0.548 rows=1,294 loops=1)

14. 0.016 0.627 ↑ 1.0 19 1

Hash (cost=34.31..34.31 rows=19 width=76) (actual time=0.627..0.627 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
15. 0.297 0.611 ↑ 1.0 19 1

Hash Right Join (cost=1.43..34.31 rows=19 width=76) (actual time=0.048..0.611 rows=19 loops=1)

  • Hash Cond: (orginfoent7_.pk = orgverific6_.org_info_pk)
16. 0.293 0.293 ↓ 1.0 1,294 1

Seq Scan on org_info orginfoent7_ (cost=0.00..27.87 rows=1,287 width=40) (actual time=0.002..0.293 rows=1,294 loops=1)

17. 0.008 0.021 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=36) (actual time=0.021..0.021 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
18. 0.013 0.013 ↑ 1.0 19 1

Seq Scan on org_verification_config orgverific6_ (cost=0.00..1.19 rows=19 width=36) (actual time=0.007..0.013 rows=19 loops=1)

19. 1.976 3.693 ↓ 1.0 5,591 1

Hash (cost=102.50..102.50 rows=5,450 width=26) (actual time=3.693..3.693 rows=5,591 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 385kB
20. 1.717 1.717 ↓ 1.0 5,591 1

Seq Scan on bank bankentity2_ (cost=0.00..102.50 rows=5,450 width=26) (actual time=0.006..1.717 rows=5,591 loops=1)