explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IKc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=172.04..172.05 rows=3 width=2,125) (actual rows= loops=)

  • Sort Key: beyanname_view.id DESC
2. 0.000 0.000 ↓ 0.0

Subquery Scan on beyanname_view (cost=0.86..172.02 rows=3 width=2,125) (actual rows= loops=)

  • Filter: (beyanname_view.bitis_tarihi >= '2019-01-13 00:00:00'::timestamp without time zone)
3. 0.000 0.000 ↓ 0.0

Append (cost=0.86..171.80 rows=9 width=2,235) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.86..54.48 rows=1 width=2,069) (actual rows= loops=)

  • Filter: ((paket.paket_durum IS NULL) OR ((paket.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
5. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_kdv1_mukellef_id_tip on beyannameler_kdv1 (cost=0.43..17.21 rows=14 width=1,703) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
6. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_kdv1.paket_id)
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.72..5.17 rows=1 width=1,609) (actual rows= loops=)

  • Filter: ((paket_1.paket_durum IS NULL) OR ((paket_1.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
8. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_kdv2_mukellef_id_tip on beyannameler_kdv2 (cost=0.29..2.51 rows=1 width=1,243) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
9. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_1 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_kdv2.paket_id)
10. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=0.85..28.01 rows=1 width=1,381) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..27.99 rows=1 width=1,373) (actual rows= loops=)

  • Filter: ((paket_2.paket_durum IS NULL) OR ((paket_2.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
12. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_damga_mukellef_id_tip on beyannameler_damga (cost=0.42..9.36 rows=7 width=1,007) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
13. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_2 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_damga.paket_id)
14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..24.22 rows=1 width=1,447) (actual rows= loops=)

  • Filter: ((paket_3.paket_durum IS NULL) OR ((paket_3.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
15. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_muhtasar_mukellef_id_tip on beyannameler_muhtasar (cost=0.42..8.24 rows=6 width=1,081) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
16. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_3 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_muhtasar.paket_id)
17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..5.02 rows=1 width=663) (actual rows= loops=)

  • Filter: ((paket_4.paket_durum IS NULL) OR ((paket_4.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
18. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_otv4_mukellef_id_tip on beyannameler_otv4 (cost=0.13..2.35 rows=1 width=297) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
19. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_4 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_otv4.paket_id)
20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.72..24.08 rows=1 width=1,027) (actual rows= loops=)

  • Filter: ((paket_5.paket_durum IS NULL) OR ((paket_5.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
21. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_muhtasar_sgk_mukellef_id_tip on beyannameler_muhtasar_sgk (cost=0.29..8.11 rows=6 width=661) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
22. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_5 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_muhtasar_sgk.paket_id)
23. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..5.30 rows=1 width=1,972) (actual rows= loops=)

  • Filter: ((paket_6.paket_durum IS NULL) OR ((paket_6.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
24. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_basit_usul_yillik_mukellef_id_tip on beyannameler_basit_usul_yillik (cost=0.42..2.64 rows=1 width=1,606) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
25. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_6 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_basit_usul_yillik.paket_id)
26. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..20.44 rows=1 width=1,854) (actual rows= loops=)

  • Filter: ((paket_7.paket_durum IS NULL) OR ((paket_7.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
27. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannameler_gecici_mukellef_id_tip on beyannameler_gecici (cost=0.42..7.12 rows=5 width=1,488) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
28. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_7 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_gecici.paket_id)
29. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.55..5.01 rows=1 width=663) (actual rows= loops=)

  • Filter: ((paket_8.paket_durum IS NULL) OR ((paket_8.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[])))
30. 0.000 0.000 ↓ 0.0

Index Scan using idx_beyannemeler_yillik_gelir_vergisi_mukellef_id_tip on beyannameler_yillik_gelir_vergisi (cost=0.12..2.35 rows=1 width=297) (actual rows= loops=)

  • Index Cond: ((mukellef_id)::text = '3030628052'::text)
  • Filter: (sube_no = '-13'::integer)
31. 0.000 0.000 ↓ 0.0

Index Scan using paket_pkey on paket paket_8 (cost=0.43..2.65 rows=1 width=374) (actual rows= loops=)

  • Index Cond: (id = beyannameler_yillik_gelir_vergisi.paket_id)
32.          

SubPlan (forSubquery Scan)

33. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Result (cost=0.01..0.02 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: ((beyanname_view.deleted IS NOT TRUE) AND ((beyanname_view.mukellef_id)::text = '3030628052'::text) AND (beyanname_view.sube_no = '-13'::integer) AND (beyanname_view.bitis_tarihi >= '2019-01-13 00:00:00'::timestamp without time zone) AND ((beyanname_view.paket_durum IS NULL) OR ((beyanname_view.paket_durum)::text <> ALL ('{CYWS_0,CYWS_B_0,DBS_B_1,DBS_B_2}'::text[]))))