explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oa2P

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

Nested Loop Left Join (cost=18.56..11,443.22 rows=1 width=833) (actual time=141.237..141.237 rows=0 loops=1)

2. 0.001 141.236 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.14..11,434.89 rows=1 width=828) (actual time=141.236..141.236 rows=0 loops=1)

  • Join Filter: (thes_snts.system_id = t3_tax_object_airvehicle.thes_snts_system_id)
3. 0.002 141.235 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.14..11,418.00 rows=1 width=775) (actual time=141.235..141.235 rows=0 loops=1)

  • Join Filter: ((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))
4. 0.007 141.233 ↓ 0.0 0 1

Nested Loop (cost=18.14..10,966.70 rows=1 width=781) (actual time=141.233..141.233 rows=0 loops=1)

  • Join Filter: ((t3_tax_object_airvehicle.airvehicle_relation_id)::text = (t3_relation_tax_object.object_relation_id)::text)
5. 0.005 141.202 ↑ 1.0 1 1

Nested Loop Semi Join (cost=17.99..10,966.40 rows=1 width=800) (actual time=60.381..141.202 rows=1 loops=1)

  • Join Filter: ((t3_tax_object_ownership.inn_id)::text = (t3_document_inn.inn)::text)
6. 0.021 141.146 ↑ 90.0 1 1

Hash Join (cost=17.99..10,941.74 rows=90 width=813) (actual time=60.325..141.146 rows=1 loops=1)

  • Hash Cond: ((t3_tax_object_airvehicle.airvehicle_relation_id)::text = (t3_tax_object_ownership.tax_object_id)::text)
7. 95.355 141.011 ↑ 90.0 1 1

Hash Right Join (cost=12.03..10,934.53 rows=90 width=739) (actual time=60.192..141.011 rows=1 loops=1)

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

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

9. 0.008 0.020 ↑ 90.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 0.012 0.012 ↑ 90.0 1 1

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

11. 0.049 0.114 ↓ 1.0 133 1

Hash (cost=4.32..4.32 rows=132 width=74) (actual time=0.114..0.114 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
12. 0.065 0.065 ↓ 1.0 133 1

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

13. 0.018 0.051 ↑ 4.0 1 1

Materialize (cost=0.00..19.27 rows=4 width=42) (actual time=0.051..0.051 rows=1 loops=1)

14. 0.033 0.033 ↑ 4.0 1 1

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

  • Filter: (tax_payer_id = '0957292e-b705-49ec-b9d6-ba283a2935c0'::uuid)
15. 0.024 0.024 ↓ 0.0 0 1

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.024..0.024 rows=0 loops=1)

  • Index Cond: ((object_relation_id)::text = (t3_tax_object_ownership.tax_object_id)::text)
  • Filter: (NOT relation_object_deleted)
  • Rows Removed by Filter: 1
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on thes_sono (cost=0.00..332.32 rows=7,932 width=15) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on thes_snts (cost=0.00..12.51 rows=351 width=74) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using thes_vktmo_pkey on thes_vktmo (cost=0.42..8.31 rows=1 width=15) (never executed)

  • Index Cond: (system_id = t3_tax_object_airvehicle.thes_vktmo_system_id)
Planning time : 3.593 ms
Execution time : 141.445 ms