explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Zqt

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

Sort (cost=107,062.01..107,062.01 rows=1 width=830) (actual rows= loops=)

  • Sort Key: r.tmpsource DESC
2. 0.000 0.000 ↓ 0.0

Subquery Scan on r (cost=107,061.00..107,062.00 rows=1 width=830) (actual rows= loops=)

  • Filter: (r.sorszam = 1)
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=107,061.00..107,061.73 rows=21 width=862) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=107,061.00..107,061.05 rows=21 width=798) (actual rows= loops=)

  • Sort Key: (CASE WHEN ((results.taxnumbertszam IS NOT NULL) AND (results.taxnumbertszam <> '0'::numeric)) THEN ((results.taxnumbertszam)::character varying)::text ELSE results.tmptaxnumber END), results.azon, results.tmpsource, results.lastlogindat DESC
5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=107,059.70..107,060.54 rows=21 width=798) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=107,059.70..107,059.75 rows=21 width=790) (actual rows= loops=)

  • Sort Key: results.companyname, results.city, results.irsz, results.addr, results.taxnumbertszam, results.azon, results.tmpsource DESC
7. 0.000 0.000 ↓ 0.0

Subquery Scan on results (cost=107,058.66..107,059.24 rows=21 width=790) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

HashAggregate (cost=107,058.66..107,058.87 rows=21 width=758) (actual rows= loops=)

  • Group Key: "*SELECT* 1".companyname, ('P'::text), "*SELECT* 1".city, "*SELECT* 1".irsz, "*SELECT* 1".addr, "*SELECT* 1".tmptaxnumber, "*SELECT* 1".taxnumbertszam, "*SELECT* 1".postname, "*SELECT* 1".postirsz, "*SELECT* 1".postcity, "*SELECT* 1".postaddr, "*SELECT* 1".taxnumbereu, "*SELECT* 1".country, "*SELECT* 1".postcountry, "*SELECT* 1".szamlabefogad, "*SELECT* 1".defaultfizmod, "*SELECT* 1".fokonyvvevoazon, "*SELECT* 1".fokonyvvevo, "*SELECT* 1".descszfej, "*SELECT* 1".defaultdeviza, "*SELECT* 1".email, "*SELECT* 1".defaultfizhatday, "*SELECT* 1".azon, "*SELECT* 1".partner_id, (('1900-01-01'::date)::timestamp without time zone)
9. 0.000 0.000 ↓ 0.0

Append (cost=3,272.00..107,057.35 rows=21 width=758) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=3,272.00..3,276.03 rows=1 width=205) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Limit (cost=3,272.00..3,276.02 rows=1 width=201) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on partner (cost=3,272.00..3,276.02 rows=1 width=201) (actual rows= loops=)

  • Recheck Cond: (((ceg_id = '63792'::numeric) AND (partname ~~* '%Bitó Andrea%'::text)) OR ((ceg_id = '63792'::numeric) AND ((partazon)::text ~~* '%Bitó Andrea%'::text)))
13. 0.000 0.000 ↓ 0.0

BitmapOr (cost=3,272.00..3,272.00 rows=1 width=0) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_partner_nev_azon_ilike (cost=0.00..1,636.00 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((ceg_id = '63792'::numeric) AND (partname ~~* '%Bitó Andrea%'::text))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_partner_nev_azon_ilike (cost=0.00..1,636.00 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((ceg_id = '63792'::numeric) AND ((partazon)::text ~~* '%Bitó Andrea%'::text))
16. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=0.00..103,781.31 rows=20 width=624) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..103,781.01 rows=20 width=540) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on ceg (cost=0.00..124,537.21 rows=24 width=540) (actual rows= loops=)

  • Filter: (cegenabled AND (cegdeletedat IS NULL) AND (NOT cegteszt) AND cegshowmetoothers AND (cegcompanyname ~~* '%Bitó Andrea%'::text) AND (cegtaxnumbertszam <> '13474919'::numeric) AND (ceglastlogindat > (now() - '180 days'::interval)))