explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uniW

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 99,259.799 ↑ 1.0 1 1

Aggregate (cost=130,654.26..130,654.27 rows=1 width=8) (actual time=99,259.799..99,259.799 rows=1 loops=1)

2. 0.037 99,259.759 ↑ 745.7 27 1

Nested Loop (cost=598.47..130,603.92 rows=20,135 width=0) (actual time=37,930.529..99,259.759 rows=27 loops=1)

3. 0.113 0.113 ↑ 1.0 1 1

Index Scan using dc_organization_adm_legacy_id_un on dc_organization dc (cost=0.29..34.59 rows=1 width=10) (actual time=0.110..0.113 rows=1 loops=1)

  • Index Cond: (adm_legacy_id IS NOT NULL)
  • Filter: ((code)::text = '45597'::text)
  • Rows Removed by Filter: 3
4. 85,986.488 99,259.609 ↑ 745.7 27 1

Bitmap Heap Scan on docs_executive e (cost=598.19..130,367.98 rows=20,135 width=6) (actual time=37,930.407..99,259.609 rows=27 loops=1)

  • Recheck Cond: (((status_id = '8'::numeric) AND ((ogai_sost_kod)::text = '45597'::text)) OR ((status_id = '9'::numeric) AND ((ogai_sost_kod)::text = '45597'::text)) OR (((status_id = '23'::numeric) AND ((ogai_sost_kod)::text = '45597'::text)) OR ((status_id = '25'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))))
  • Filter: ((status_id = '8'::numeric) OR (status_id = '9'::numeric) OR (((status_id = '23'::numeric) OR (status_id = '25'::numeric)) AND (alternatives: SubPlan 1 or hashed SubPlan 2)))
  • Rows Removed by Filter: 27,890
  • Heap Blocks: exact=40,824
5. 8.946 11,119.557 ↓ 0.0 0 1

BitmapOr (cost=598.19..598.19 rows=32,286 width=0) (actual time=11,119.557..11,119.557 rows=0 loops=1)

6. 958.793 958.793 ↓ 2.5 10,028 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..73.55 rows=4,072 width=0) (actual time=958.792..958.793 rows=10,028 loops=1)

  • Index Cond: ((status_id = '8'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))
7. 8.925 8.925 ↑ 45.8 89 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..73.55 rows=4,072 width=0) (actual time=8.925..8.925 rows=89 loops=1)

  • Index Cond: ((status_id = '9'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))
8. 0.002 10,142.893 ↓ 0.0 0 1

BitmapOr (cost=440.76..440.76 rows=24,143 width=0) (actual time=10,142.893..10,142.893 rows=0 loops=1)

9. 9,907.019 9,907.019 ↓ 1.8 36,880 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..357.14 rows=20,071 width=0) (actual time=9,907.019..9,907.019 rows=36,880 loops=1)

  • Index Cond: ((status_id = '23'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))
10. 235.872 235.872 ↑ 2.3 1,800 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..73.55 rows=4,072 width=0) (actual time=235.872..235.872 rows=1,800 loops=1)

  • Index Cond: ((status_id = '25'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))
11.          

SubPlan (for Bitmap Heap Scan)

12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using docs_executive_response_idx1 on docs_executive_response r (cost=0.42..2.85 rows=1 width=0) (never executed)

  • Index Cond: ((docs_id = e.docs_id) AND (docs_type = '1'::numeric) AND (process_status = '-1'::numeric))
  • Heap Fetches: 0
13. 2,153.564 2,153.564 ↑ 208.8 56 1

Index Only Scan using docs_executive_response_idx1 on docs_executive_response r_1 (cost=0.42..16,983.58 rows=11,691 width=6) (actual time=1,216.483..2,153.564 rows=56 loops=1)

  • Index Cond: ((docs_type = '1'::numeric) AND (process_status = '-1'::numeric))
  • Heap Fetches: 56
Planning time : 0.997 ms
Execution time : 99,260.695 ms