explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HT8s

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 304.913 ↑ 5.7 7 1

GroupAggregate (cost=4,499.290..4,500.430 rows=40 width=16) (actual time=304.910..304.913 rows=7 loops=1)

  • Group Key: (papa_five('seven'::text, (((papa_tango('five_zulu'::text, victor, 'four'::text[]))[1])::text)::timestamp without time zone))
2. 0.022 304.904 ↑ 1.9 24 1

Sort (cost=4,499.290..4,499.400 rows=45 width=8) (actual time=304.903..304.904 rows=24 loops=1)

  • Sort Key: (papa_five('seven'::text, (((papa_tango('five_zulu'::text, victor, 'four'::text[]))[1])::text)::timestamp without time zone))
  • Sort Method: quicksort Memory: 26kB
3. 304.882 304.882 ↑ 1.9 24 1

Index Scan using alpha_victor on five_papa hotel (cost=0.290..4,498.050 rows=45 width=8) (actual time=301.634..304.882 rows=24 loops=1)

  • Index Cond: (((papa_tango('mike'::text, victor, 'four'::text[]))[1])::text = 'juliet'::text)
  • Filter: (((((papa_tango('foxtrot'::text, victor, 'four'::text[]))[1])::text)::date)::timestamp without time zone = 'alpha_golf'::timestamp without time zone)
  • Rows Removed by Filter: 8,929
Planning time : 0.394 ms