explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iDbH

Settings
# exclusive inclusive rows x rows loops node
1. 2.488 19,231.603 ↓ 0.0 0 1

Nested Loop (cost=10,975.94..38,182.37 rows=1 width=833) (actual time=19,231.603..19,231.603 rows=0 loops=1)

  • Join Filter: ((t3_tax_object_airvehicle.airvehicle_relation_id)::text = (t3_relation_tax_object.object_relation_id)::text)
  • Rows Removed by Join Filter: 75
2. 2.637 4.665 ↓ 75.0 75 1

Hash Right Join (cost=24.43..416.25 rows=1 width=110) (actual time=3.174..4.665 rows=75 loops=1)

  • Hash Cond: ((thes_sono.record_id = t3_relation_tax_object.thes_sono_record_id) AND (thes_sono.version_id = t3_relation_tax_object.thes_sono_version_id))
3. 1.226 1.226 ↑ 1.0 7,932 1

Seq Scan on thes_sono (cost=0.00..332.32 rows=7,932 width=15) (actual time=0.010..1.226 rows=7,932 loops=1)

4. 0.076 0.802 ↓ 75.0 75 1

Hash (cost=24.42..24.42 rows=1 width=116) (actual time=0.802..0.802 rows=75 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
5. 0.169 0.726 ↓ 75.0 75 1

Nested Loop (cost=19.45..24.42 rows=1 width=116) (actual time=0.102..0.726 rows=75 loops=1)

6. 0.083 0.177 ↓ 76.0 76 1

Hash Join (cost=19.30..24.13 rows=1 width=61) (actual time=0.088..0.177 rows=76 loops=1)

  • Hash Cond: ((t3_tax_object_ownership.inn_id)::text = (t3_document_inn.inn)::text)
7. 0.038 0.038 ↓ 1.0 133 1

Seq Scan on t3_tax_object_ownership (cost=0.00..4.32 rows=132 width=74) (actual time=0.019..0.038 rows=133 loops=1)

8. 0.037 0.056 ↑ 4.0 1 1

Hash (cost=19.25..19.25 rows=4 width=42) (actual time=0.056..0.056 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.019 0.019 ↑ 4.0 1 1

Seq Scan on t3_document_inn (cost=0.00..19.25 rows=4 width=42) (actual time=0.017..0.019 rows=1 loops=1)

  • Filter: (tax_payer_id = '0957292e-b705-49ec-b9d6-ba283a2935c0'::uuid)
  • Rows Removed by Filter: 12
10. 0.380 0.380 ↑ 1.0 1 76

Index Scan using t3_relation_tax_object_pkey on t3_relation_tax_object (cost=0.14..0.28 rows=1 width=55) (actual time=0.005..0.005 rows=1 loops=76)

  • Index Cond: ((object_relation_id)::text = (t3_tax_object_ownership.tax_object_id)::text)
  • Filter: (NOT relation_object_deleted)
  • Rows Removed by Filter: 0
11. 13,209.367 19,224.450 ↑ 90.0 1 75

Hash Right Join (cost=10,951.51..37,764.98 rows=90 width=785) (actual time=250.779..256.326 rows=1 loops=75)

  • Hash Cond: (thes_vktmo.system_id = t3_tax_object_airvehicle.thes_vktmo_system_id)
12. 5,878.575 5,878.575 ↑ 1.0 461,787 75

Seq Scan on thes_vktmo (cost=0.00..25,080.87 rows=461,787 width=15) (actual time=0.006..78.381 rows=461,787 loops=75)

13. 0.018 136.508 ↑ 90.0 1 1

Hash (cost=10,950.38..10,950.38 rows=90 width=792) (actual time=136.508..136.508 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 94.567 136.490 ↑ 90.0 1 1

Hash Right Join (cost=27.88..10,950.38 rows=90 width=792) (actual time=58.759..136.490 rows=1 loops=1)

  • Hash Cond: (thes_okato.system_id = t3_tax_object_airvehicle.thes_okato_system_id)
15. 41.709 41.709 ↑ 1.0 325,711 1

Seq Scan on thes_okato (cost=0.00..9,700.17 rows=325,717 width=18) (actual time=0.014..41.709 rows=325,711 loops=1)

16. 0.005 0.214 ↑ 90.0 1 1

Hash (cost=26.75..26.75 rows=90 width=796) (actual time=0.214..0.214 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.116 0.209 ↑ 90.0 1 1

Hash Right Join (cost=12.03..26.75 rows=90 width=796) (actual time=0.205..0.209 rows=1 loops=1)

  • Hash Cond: (thes_snts.system_id = t3_tax_object_airvehicle.thes_snts_system_id)
18. 0.070 0.070 ↑ 1.0 351 1

Seq Scan on thes_snts (cost=0.00..12.51 rows=351 width=74) (actual time=0.014..0.070 rows=351 loops=1)

19. 0.005 0.023 ↑ 90.0 1 1

Hash (cost=10.90..10.90 rows=90 width=743) (actual time=0.023..0.023 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.018 0.018 ↑ 90.0 1 1

Seq Scan on t3_tax_object_airvehicle (cost=0.00..10.90 rows=90 width=743) (actual time=0.018..0.018 rows=1 loops=1)

Planning time : 3.299 ms
Execution time : 19,231.761 ms