explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DQyK

Settings
# exclusive inclusive rows x rows loops node
1. 0.382 4.140 ↓ 1.8 38 1

Sort (cost=105.62..105.67 rows=21 width=84) (actual time=3.966..4.140 rows=38 loops=1)

  • Sort Key: ff.concept_desc
  • Sort Method: quicksort Memory: 30kB
2. 0.440 3.758 ↓ 1.8 38 1

Hash Left Join (cost=7.92..105.16 rows=21 width=84) (actual time=2.790..3.758 rows=38 loops=1)

  • Hash Cond: (ff.country_id = cc.country_id)
3. 0.300 1.339 ↓ 1.8 38 1

Nested Loop (cost=0.28..96.92 rows=21 width=76) (actual time=0.761..1.339 rows=38 loops=1)

4. 0.039 0.039 ↑ 1.0 1 1

Index Scan using ht_gm_schema_financial_percentage_pkey on financial_percentage_result fpr (cost=0.28..5.30 rows=1 width=31) (actual time=0.034..0.039 rows=1 loops=1)

  • Index Cond: (((initiative_id)::text = 'INIFR201903140000000745'::text) AND (concept_id = 5))
5. 1.000 1.000 ↓ 1.8 38 1

Seq Scan on fact_financial ff (cost=0.00..91.41 rows=21 width=75) (actual time=0.712..1.000 rows=38 loops=1)

  • Filter: ((concept_financial_id = 5) AND ((initiative_id)::text = 'INIFR201903140000000745'::text))
  • Rows Removed by Filter: 2,656
6. 0.988 1.979 ↑ 1.0 251 1

Hash (cost=4.51..4.51 rows=251 width=16) (actual time=1.979..1.979 rows=251 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
7. 0.991 0.991 ↑ 1.0 251 1

Seq Scan on cat_iso_country cc (cost=0.00..4.51 rows=251 width=16) (actual time=0.009..0.991 rows=251 loops=1)

Planning time : 0.461 ms
Execution time : 4.408 ms