explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TZCvP

Settings
# exclusive inclusive rows x rows loops node
1. 23,439.830 23,439.830 ↓ 99.0 99 1

Sort (cost=23,528.71..23,528.71 rows=1 width=598) (actual time=23,439.798..23,439.830 rows=99 loops=1)

  • Sort Key: a.createddate DESC
  • Sort Method: quicksort Memory: 76kB
  • -> Nested Loop Left Join (cost=16301.16..23528.70 rows=1 width=598) (actual time=570.487..23439.377 rows=99 loops=1
  • -> Nested Loop Left Join (cost=16300.87..23528.25 rows=1 width=488) (actual time=570.203..23433.207 rows=99 l
  • Join Filter: ((a.id)::text = (c.receiptheader)::text)
  • Rows Removed by Join Filter: 1010790
  • -> Nested Loop Left Join (cost=16300.87..23160.17 rows=1 width=451) (actual time=567.205..22926.830 row
  • Join Filter: ((a.id)::text = (egcl_receiptdetails.receiptheader)::text)
  • Rows Removed by Join Filter: 1010790
  • -> Nested Loop (cost=318.21..1320.13 rows=1 width=158) (actual time=5.632..12.742 rows=99 loops=1
  • -> Hash Join (cost=317.92..949.09 rows=48 width=81) (actual time=5.607..9.713 rows=99 loops
  • Hash Cond: ((bb.property)::text = (aa.property)::text)
  • -> Seq Scan on eg_pt_propertydetail_v2 bb (cost=0.00..590.87 rows=10587 width=43) (ac
  • -> Hash (cost=317.58..317.58 rows=27 width=20) (actual time=2.013..2.013 rows=27 loop
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • -> Seq Scan on eg_pt_address_v2 aa (cost=0.00..317.58 rows=27 width=20) (actual
  • Filter: ((locality)::text = ANY ('{P_1,P_2,P_3,P_4,P_5,P_6,P_7,P_8,P_9,P_10
  • Rows Removed by Filter: 5892
  • -> Index Scan using idx_rcpthd_consumercode on egcl_receiptheader a (cost=0.29..7.72 rows=1
  • Index Cond: ((consumercode)::text = concat(aa.property, ':', bb.assessmentnumber))
  • Filter: (((tenantid)::text ~~ 'pb.amloh'::text) AND (createddate >= '1541010600000'::bi
  • -> GroupAggregate (cost=15982.66..21611.48 rows=10158 width=293) (actual time=3.718..228.718 rows
  • Group Key: egcl_receiptdetails.receiptheader
  • -> Sort (cost=15982.66..16222.36 rows=95878 width=88) (actual time=3.692..35.790 rows=95867
  • Sort Key: egcl_receiptdetails.receiptheader
  • Sort Method: external sort Disk: 9224kB
  • -> Seq Scan on egcl_receiptdetails (cost=0.00..3460.78 rows=95878 width=88) (actual t
  • -> Seq Scan on egcl_receiptinstrument c (cost=0.00..239.70 rows=10270 width=74) (actual time=0.007..2.4
  • -> Index Scan using pk_egcl_instrumenthead on egcl_instrumentheader b (cost=0.29..0.42 rows=1 width=80) (actu
  • Index Cond: ((id)::text = (c.instrumentheader)::text)