explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcQ

Settings
# exclusive inclusive rows x rows loops node
1. 529.247 11,977.314 ↓ 1,129.4 135,524 1

Nested Loop Anti Join (cost=0.99..19,148.46 rows=120 width=983) (actual time=0.128..11,977.314 rows=135,524 loops=1)

2. 2,130.979 2,130.979 ↓ 1,427.2 388,212 1

Index Scan using test_gst_1 on test_gst a (cost=0.42..18,430.70 rows=272 width=983) (actual time=0.071..2,130.979 rows=388,212 loops=1)

  • Index Cond: ((top_tax_group >= 130001) AND (top_tax_group <= 800000) AND (test_func_gst(dt_reg) <= 201811) AND (test_func_gst_dtdereg(dt_dereg) >= 201811) AND (CASE WHEN (gst_comp = 'Y'::bpchar) THEN 'Y'::text ELSE 'N'::text END = 'N'::text))
  • Filter: (st_cn_jurd = 'S'::bpchar)
  • Rows Removed by Filter: 175159
3. 9,317.088 9,317.088 ↑ 1.0 1 388,212

Index Only Scan using pk_form_gstr3b on form_gstr3b c (cost=0.56..2.62 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=388,212)

  • Index Cond: ((gstin = a.provisional_id) AND (ret_period = 112018))
  • Heap Fetches: 945