explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eKbU

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 1,350.782 ↑ 16.0 3 1

Aggregate (cost=789,017.99..789,019.33 rows=48 width=44) (actual time=1,349.094..1,350.782 rows=3 loops=1)

  • Buffers: shared hit=67,192 read=45,708 written=6,152
2. 0.038 1,350.712 ↑ 5.0 10 1

Sort (cost=789,017.99..789,018.11 rows=50 width=27) (actual time=1,349.054..1,350.712 rows=10 loops=1)

  • Sort Key: fact_claim.claim_sequence
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=67,192 read=45,708 written=6,152
3. 0.044 1,350.674 ↑ 5.0 10 1

Nested Loop (cost=760,982.4..789,016.58 rows=50 width=27) (actual time=1,232.48..1,350.674 rows=10 loops=1)

  • Buffers: shared hit=67,192 read=45,708 written=6,152
4. 73.404 1,350.560 ↑ 5.0 10 1

Hash Join (cost=760,981.97..788,991.51 rows=50 width=16) (actual time=1,232.448..1,350.56 rows=10 loops=1)

  • Buffers: shared hit=67,152 read=45,708 written=6,152
5. 765.407 765.407 ↑ 1.1 654,869 1

Seq Scan on fact_deduction_claim dc (cost=0..25,420.83 rows=690,188 width=41) (actual time=628.276..765.407 rows=654,869 loops=1)

  • Filter: (dc.date_claim_match_link_removed IS NULL)
  • Buffers: shared hit=18,325
6. 0.038 511.749 ↑ 16.0 3 1

Hash (cost=760,981.37..760,981.37 rows=48 width=49) (actual time=510.103..511.749 rows=3 loops=1)

  • Buffers: shared hit=48,827 read=45,708 written=6,152
7. 0.009 511.711 ↑ 16.0 3 1

Unique (cost=760,980.53..760,980.89 rows=48 width=49) (actual time=510.059..511.711 rows=3 loops=1)

  • Buffers: shared hit=48,827 read=45,708 written=6,152
8. 0.040 511.702 ↑ 6.0 8 1

Sort (cost=760,980.53..760,980.65 rows=48 width=49) (actual time=510.057..511.702 rows=8 loops=1)

  • Sort Key: fact_claim.claim_sequence, fact_claim.claim_id
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=48,827 read=45,708 written=6,152
9. 45.655 511.662 ↑ 6.0 8 1

Gather (cost=12,458.3..760,979.19 rows=48 width=49) (actual time=259.157..511.662 rows=8 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=48,827 read=45,708 written=6,152
10. 450.719 466.007 ↑ 6.0 2 5 / 5

Bitmap Heap Scan on fact_claim fact_claim (cost=11,458.3..759,974.39 rows=12 width=49) (actual time=378.152..466.007 rows=2 loops=5)

  • Filter: ((fact_claim.claim_sequence)::text = ANY ('{1173307,1072047,1104820}'::text[]))
  • Heap Blocks: exact=37,546
  • Buffers: shared hit=48,827 read=45,708 written=6,152
11. 15.288 15.288 ↓ 1.0 927,233 1 / 5

Bitmap Index Scan on fact_claim_client_sk_idx (cost=0..11,458.29 rows=926,297 width=0) (actual time=76.441..76.441 rows=927,233 loops=1)

  • Index Cond: (fact_claim.client_sk = 8)
  • Buffers: shared read=2,665
12. 0.070 0.070 ↑ 1.0 1 10

Index Scan using dim_deduction_pkey on dim_deduction dd_x (cost=0.42..0.5 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=10)

  • Index Cond: (dd_x.deduction_sk = dc.deduction_sk)
  • Filter: ((dd_x.deduction_number)::text IS NOT NULL)
  • Buffers: shared hit=40
Planning time : 1.206 ms
Execution time : 1,357.99 ms