explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WKT7

Settings
# exclusive inclusive rows x rows loops node
1. 35,160.629 224,052.004 ↓ 15.7 537,530 1

HashAggregate (cost=4,874,313.75..4,875,338.07 rows=34,144 width=140) (actual time=223,133.747..224,052.004 rows=537,530 loops=1)

2. 7,957.319 188,891.375 ↓ 541.2 18,479,645 1

Hash Left Join (cost=4,686,096.61..4,873,118.71 rows=34,144 width=140) (actual time=164,402.772..188,891.375 rows=18,479,645 loops=1)

  • Hash Cond: (sitemapping.siteid = sitemaster.id)
3. 5,516.290 180,933.532 ↓ 541.2 18,479,645 1

Merge Left Join (cost=4,686,037.03..4,872,376.25 rows=34,144 width=140) (actual time=164,402.232..180,933.532 rows=18,479,645 loops=1)

  • Merge Cond: ((public.bsckpilaccelltable.cellid = sitemapping.cellid) AND (public.bsckpilaccelltable.lac = sitemapping.lacid) AND (public.bsckpilaccelltable.omcid = public.omcmasterinfo.seq_no))
4. 7,486.321 174,750.264 ↓ 540.3 18,479,645 1

Merge Join (cost=4,685,238.41..4,871,249.14 rows=34,200 width=130) (actual time=164,395.987..174,750.264 rows=18,479,645 loops=1)

  • Merge Cond: ((public.bsckpierlangtable.cellid = public.bsckpilaccelltable.cellid) AND (public.bsckpierlangtable.lac = public.bsckpilaccelltable.lac) AND (public.bsckpierlangtable.omcid = public.bsckpilaccelltable.omcid) AND (public.bsckpierlangtable.rectimestamp = public.bsckpilaccelltable.rectimestamp))
5. 17,935.954 108,844.935 ↑ 1.5 4,582,542 1

Sort (cost=2,946,831.26..2,963,744.95 rows=6,765,479 width=102) (actual time=108,206.145..108,844.935 rows=4,582,542 loops=1)

  • Sort Key: public.bsckpierlangtable.cellid, public.bsckpierlangtable.lac, public.omcmasterinfo.seq_no, public.bsckpierlangtable.rectimestamp
  • Sort Method: quicksort Memory: 853699kB
6. 1,968.824 90,908.981 ↑ 1.5 4,582,542 1

Hash Join (cost=25.14..2,179,295.76 rows=6,765,479 width=102) (actual time=18.611..90,908.981 rows=4,582,542 loops=1)

  • Hash Cond: (public.bsckpierlangtable.omcid = public.omcmasterinfo.seq_no)
7. 1,064.825 88,939.846 ↑ 1.0 11,660,564 1

Append (cost=0.00..2,067,659.89 rows=11,721,585 width=44) (actual time=0.016..88,939.846 rows=11,660,564 loops=1)

8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on bsckpierlangtable (cost=0.00..0.00 rows=1 width=44) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((cellid >= 0::bigint) AND (lac >= 0::bigint) AND (rectimestamp >= '2018-04-30 18:30:00'::timestamp without time zone) AND (rectimestamp <= '2018-05-29 18:29:59.999'::timestamp without time zone) AND (chantype = 1))
9. 87,875.020 87,875.020 ↑ 1.0 11,660,564 1

Seq Scan on bsckpierlangtable_052018 bsckpierlangtable (cost=0.00..2,067,659.89 rows=11,721,584 width=44) (actual time=0.015..87,875.020 rows=11,660,564 loops=1)

  • Filter: ((cellid >= 0::bigint) AND (lac >= 0::bigint) AND (rectimestamp >= '2018-04-30 18:30:00'::timestamp without time zone) AND (rectimestamp <= '2018-05-29 18:29:59.999'::timestamp without time zone) AND (chantype = 1))
  • Rows Removed by Filter: 35571519
10. 0.052 0.311 ↑ 1.0 172 1

Hash (cost=22.99..22.99 rows=172 width=58) (actual time=0.311..0.311 rows=172 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
11. 0.085 0.259 ↑ 1.0 172 1

Hash Join (cost=12.16..22.99 rows=172 width=58) (actual time=0.159..0.259 rows=172 loops=1)

  • Hash Cond: ((public.omcmasterinfo.neip)::text = (public.kpissa.neip)::text)
12. 0.028 0.028 ↑ 1.0 299 1

Seq Scan on omcmasterinfo (cost=0.00..7.99 rows=299 width=38) (actual time=0.003..0.028 rows=299 loops=1)

13. 0.045 0.146 ↑ 1.0 170 1

Hash (cost=10.03..10.03 rows=170 width=31) (actual time=0.146..0.146 rows=170 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
14. 0.101 0.101 ↑ 1.0 170 1

Seq Scan on kpissa (cost=0.00..10.03 rows=170 width=31) (actual time=0.005..0.101 rows=170 loops=1)

  • Filter: ((ssaname)::text = ANY ('{select,GAYA,KHAMMAM,BALAGHAT,HAZARIBAGH,RANCHI,RAIPUR,MUNGER,BOKARO,BEHRAMPUR,CHANDRAPUR}'::text[]))
  • Rows Removed by Filter: 126
15. 11,254.092 58,419.008 ↓ 2.9 23,639,057 1

Sort (cost=1,738,407.15..1,758,627.20 rows=8,088,020 width=44) (actual time=56,189.831..58,419.008 rows=23,639,057 loops=1)

  • Sort Key: public.bsckpilaccelltable.cellid, public.bsckpilaccelltable.lac, public.bsckpilaccelltable.omcid, public.bsckpilaccelltable.rectimestamp
  • Sort Method: quicksort Memory: 831017kB
16. 734.510 47,164.916 ↓ 1.0 8,120,432 1

Append (cost=0.00..810,413.81 rows=8,088,020 width=44) (actual time=0.024..47,164.916 rows=8,120,432 loops=1)

17. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on bsckpilaccelltable (cost=0.00..0.00 rows=1 width=44) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((cellid >= 0::bigint) AND (lac >= 0::bigint) AND (rectimestamp >= '2018-04-30 18:30:00'::timestamp without time zone) AND (rectimestamp <= '2018-05-29 18:29:59.999'::timestamp without time zone) AND (chantype = 1))
18. 46,430.404 46,430.404 ↓ 1.0 8,120,432 1

Seq Scan on bsckpilaccelltable_052018 bsckpilaccelltable (cost=0.00..810,413.81 rows=8,088,019 width=44) (actual time=0.022..46,430.404 rows=8,120,432 loops=1)

  • Filter: ((cellid >= 0::bigint) AND (lac >= 0::bigint) AND (rectimestamp >= '2018-04-30 18:30:00'::timestamp without time zone) AND (rectimestamp <= '2018-05-29 18:29:59.999'::timestamp without time zone) AND (chantype = 1))
  • Rows Removed by Filter: 4509381
19. 663.461 666.978 ↓ 1,254.3 9,027,520 1

Sort (cost=798.62..816.61 rows=7,197 width=50) (actual time=6.241..666.978 rows=9,027,520 loops=1)

  • Sort Key: sitemapping.cellid, sitemapping.lacid, public.omcmasterinfo.seq_no
  • Sort Method: quicksort Memory: 947kB
20. 2.472 3.517 ↑ 1.0 6,902 1

Hash Join (cost=25.50..337.54 rows=7,197 width=50) (actual time=0.284..3.517 rows=6,902 loops=1)

  • Hash Cond: ((sitemapping.neip)::text = (public.omcmasterinfo.neip)::text)
21. 0.780 0.780 ↑ 1.0 7,738 1

Seq Scan on sitemapping (cost=0.00..201.38 rows=7,738 width=57) (actual time=0.008..0.780 rows=7,738 loops=1)

22. 0.047 0.265 ↑ 1.1 281 1

Hash (cost=21.76..21.76 rows=299 width=26) (actual time=0.265..0.265 rows=281 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
23. 0.100 0.218 ↑ 1.1 281 1

Hash Join (cost=9.66..21.76 rows=299 width=26) (actual time=0.097..0.218 rows=281 loops=1)

  • Hash Cond: ((public.omcmasterinfo.neip)::text = (public.kpissa.neip)::text)
24. 0.033 0.033 ↑ 1.0 299 1

Seq Scan on omcmasterinfo (cost=0.00..7.99 rows=299 width=15) (actual time=0.003..0.033 rows=299 loops=1)

25. 0.053 0.085 ↑ 1.0 296 1

Hash (cost=5.96..5.96 rows=296 width=11) (actual time=0.085..0.085 rows=296 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
26. 0.032 0.032 ↑ 1.0 296 1

Seq Scan on kpissa (cost=0.00..5.96 rows=296 width=11) (actual time=0.003..0.032 rows=296 loops=1)

27. 0.283 0.524 ↑ 1.0 1,937 1

Hash (cost=35.37..35.37 rows=1,937 width=8) (actual time=0.524..0.524 rows=1,937 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 79kB
28. 0.241 0.241 ↑ 1.0 1,937 1

Seq Scan on sitemaster (cost=0.00..35.37 rows=1,937 width=8) (actual time=0.005..0.241 rows=1,937 loops=1)