explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mIQ9

Settings
# exclusive inclusive rows x rows loops node
1. 755.225 12,224.662 ↓ 6.6 135,524 1

Nested Loop Anti Join (cost=0.99..198,106.44 rows=20,535 width=982) (actual time=0.326..12,224.662 rows=135,524 loops=1)

2. 1,375.925 1,375.925 ↓ 8.4 388,212 1

Index Scan using test_gst_1 on test_gst a (cost=0.42..101,952.42 rows=46,489 width=982) (actual time=0.265..1,375.925 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 (st_cn_jurd = 'S'::bpchar))
  • Filter: (gst_comp IS NULL)
  • Rows Removed by Filter: 87439
3. 10,093.512 10,093.512 ↑ 1.0 1 388,212

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

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