explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fiE6

Settings
# exclusive inclusive rows x rows loops node
1. 2,407.641 10,824.933 ↑ 7,361.6 25 1

Index Only Scan using "IDX_TEXT_ID_TIMESTAMP" on "TEXT_INFO" "N" (cost=0.56..19,932,216.04 rows=184,039 width=45) (actual time=582.968..10,824.933 rows=25 loops=1)

  • Index Cond: (("TIMESTAMP" >= '2019-12-30 00:00:00'::timestamp without time zone) AND ("TIMESTAMP" <= '2020-02-07 00:00:00'::timestamp without time zone))
  • Filter: (((SubPlan 1) IS NOT NULL) AND (NOT (SubPlan 3)) AND (SubPlan 2))
  • Rows Removed by Filter: 764917
  • Heap Fetches: 551240
2.          

SubPlan (for Index Only Scan)

3. 8,414.362 8,414.362 ↓ 0.0 0 764,942

Index Only Scan using "IDX_TEXT_TO_COMPANY" on "TEXT_TO_COMPANY" ttc (cost=0.69..8.71 rows=1 width=34) (actual time=0.011..0.011 rows=0 loops=764,942)

  • Index Cond: (("TEXT_ID" = ("N"."ID")::text) AND ("COMPANY_ID" = '14437'::text))
  • Heap Fetches: 118
4. 2.282 2.282 ↑ 1.0 1 163

Index Scan using "IDX_TEXT_TO_COMPANY" on "TEXT_TO_COMPANY" ttc_2 (cost=0.69..8.71 rows=1 width=1) (actual time=0.013..0.014 rows=1 loops=163)

  • Index Cond: ((("TEXT_ID")::text = ("N"."ID")::text) AND (("COMPANY_ID")::text = '14437'::text))
5. 0.648 0.648 ↑ 1.0 1 54

Index Scan using "IDX_TEXT_TO_COMPANY" on "TEXT_TO_COMPANY" ttc_1 (cost=0.69..8.71 rows=1 width=1) (actual time=0.012..0.012 rows=1 loops=54)

  • Index Cond: ((("TEXT_ID")::text = ("N"."ID")::text) AND (("COMPANY_ID")::text = '14437'::text))
Planning time : 0.747 ms
Execution time : 10,825.207 ms