explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CgOZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.819 ↑ 25.0 6 1

Nested Loop (cost=190.94..405.53 rows=150 width=59) (actual time=0.762..0.819 rows=6 loops=1)

2.          

CTE doc_control_location_mapping

3. 0.015 0.695 ↑ 25.0 6 1

HashAggregate (cost=189.16..190.66 rows=150 width=8) (actual time=0.691..0.695 rows=6 loops=1)

  • Group Key: dc.soldbylocid
4. 0.005 0.680 ↑ 25.0 6 1

Append (cost=0.29..188.78 rows=150 width=8) (actual time=0.072..0.680 rows=6 loops=1)

5. 0.597 0.597 ↑ 25.0 2 1

Index Scan using pk_doccontrol_id on document_control dc (cost=0.29..62.43 rows=50 width=8) (actual time=0.071..0.597 rows=2 loops=1)

  • Index Cond: (id = ANY ('{71270,82628,70388,84671,76568,71344,78745,67360,71649,85140,86021,76543,69921,85326,108022,84692,70298,67440,72207,71972
  • Filter: (soldbylocid IS NOT NULL)
6. 0.039 0.039 ↑ 25.0 2 1

Index Scan using pk_doccontrol_id on document_control dc_1 (cost=0.29..62.43 rows=50 width=8) (actual time=0.035..0.039 rows=2 loops=1)

  • Index Cond: (id = ANY ('{71270,82628,70388,84671,76568,71344,78745,67360,71649,85140,86021,76543,69921,85326,108022,84692,70298,67440,72207,71972
  • Filter: (soldtolocid IS NOT NULL)
7. 0.039 0.039 ↑ 25.0 2 1

Index Scan using pk_doccontrol_id on document_control dc_2 (cost=0.29..62.43 rows=50 width=8) (actual time=0.034..0.039 rows=2 loops=1)

  • Index Cond: (id = ANY ('{71270,82628,70388,84671,76568,71344,78745,67360,71649,85140,86021,76543,69921,85326,108022,84692,70298,67440,72207,71972
  • Filter: (shiptolocid IS NOT NULL)
8. 0.700 0.700 ↑ 25.0 6 1

CTE Scan on doc_control_location_mapping dclm (cost=0.00..3.00 rows=150 width=8) (actual time=0.693..0.700 rows=6 loops=1)

9. 0.102 0.102 ↑ 1.0 1 6

Index Scan using pk_geolocation_id on geo_location gl (cost=0.29..1.40 rows=1 width=59) (actual time=0.016..0.017 rows=1 loops=6)

  • Index Cond: (id = dclm.locid)